CREATE TABLE [dbo].[GroupTypeRef]
(
[GroupTypeKey] [uniqueidentifier] NOT NULL,
[GroupTypeName] [nvarchar] (65) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsSystem] [bit] NOT NULL CONSTRAINT [DF_GroupTypeRef_IsSystem] DEFAULT ((0)),
[IsPaymentRequired] [bit] NOT NULL CONSTRAINT [DF_GroupTypeRef_IsPaymentRequired] DEFAULT ((0)),
[IsDateLimited] [bit] NOT NULL CONSTRAINT [DF_GroupTypeRef_IsDateLimited] DEFAULT ((0)),
[GroupMemberBranchName] [nvarchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IsInvitationOnly] [bit] NOT NULL,
[DefaultGroupStatusCode] [nvarchar] (4) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[IsSimpleGroup] [bit] NOT NULL CONSTRAINT [DF_GroupTypeRef_IsSimpleGroup] DEFAULT ((0)),
[MemberQueryFolderKey] [uniqueidentifier] NULL,
[InheritRolesFlag] [bit] NOT NULL CONSTRAINT [DF_GroupTypeRef_InheritRolesFlag] DEFAULT ((0)),
[IsSingleRole] [bit] NOT NULL CONSTRAINT [DF_GroupTypeRef_IsSingleRole] DEFAULT ((0)),
[GroupTypeDesc] [nvarchar] (250) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CreatedByUserKey] [uniqueidentifier] NOT NULL,
[UpdatedByUserKey] [uniqueidentifier] NOT NULL,
[CreatedOn] [datetime] NOT NULL,
[UpdatedOn] [datetime] NOT NULL,
[LandingPageContentKey] [uniqueidentifier] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[GroupTypeRef] ADD CONSTRAINT [PK_GroupTypeRef] PRIMARY KEY CLUSTERED ([GroupTypeKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GroupTypeRef] ADD CONSTRAINT [AK_GroupTypeRef_GroupTypeName] UNIQUE NONCLUSTERED ([GroupTypeName]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_GroupTypeRef_CreatedByUserKey] ON [dbo].[GroupTypeRef] ([CreatedByUserKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_GroupTypeRef_DefaultGroupStatusCode] ON [dbo].[GroupTypeRef] ([DefaultGroupStatusCode]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_GroupTypeRef_MemberQueryFolderKey] ON [dbo].[GroupTypeRef] ([MemberQueryFolderKey]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_GroupTypeRef_UpdatedByUserKey] ON [dbo].[GroupTypeRef] ([UpdatedByUserKey]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[GroupTypeRef] ADD CONSTRAINT [FK_GroupTypeRef_DocumentMain] FOREIGN KEY ([MemberQueryFolderKey]) REFERENCES [dbo].[DocumentMain] ([DocumentKey])
GO
ALTER TABLE [dbo].[GroupTypeRef] ADD CONSTRAINT [FK_GroupTypeRef_GroupStatusRef] FOREIGN KEY ([DefaultGroupStatusCode]) REFERENCES [dbo].[GroupStatusRef] ([GroupStatusCode])
GO
ALTER TABLE [dbo].[GroupTypeRef] ADD CONSTRAINT [FK_GroupTypeRef_UserMain_CreatedBy] FOREIGN KEY ([CreatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO
ALTER TABLE [dbo].[GroupTypeRef] ADD CONSTRAINT [FK_GroupTypeRef_UserMain_UpdatedBy] FOREIGN KEY ([UpdatedByUserKey]) REFERENCES [dbo].[UserMain] ([UserKey])
GO